FO_Users
[update to this table: 04-06-2016]
[last update to this table: 04-16-2016]
Each record in this table represents a single user. The core component of these entries is the user name and the value must be a unique entry in this table. The user name may be the user’s network id or an arbitrary name assigned by the administrator. The system is able to automatically check for the network user name that is logged in to the windows session and default it in the user login screen.
Field | Type | Notes |
---|---|---|
UserName |
varchar(50) |
Enter a unique name for this user. May be the network user name or ID for that user. A person may have more than one user name, each with a different set of permissions or locations for example. |
UserPassword |
varchar(50) |
Enter a password for first-time log in. If the password is not encrypted, the user will be required to enter a new password which will then be encrypted by the system. Not used if the auto-login feature is utilized. |
FacilityID |
varchar(50) |
Default facility ID. Enter a valid facility ID. May be the same as HID. |
FullName |
varchar(80) |
Enter user’s full name using a convention assigned by the administrator. IE: John Doe |
EntryGroupCode |
varchar(50) |
A code assigned by the administrator. Enter a group code, preferably only 3-5 characters. Skip this entry if the system will only contain lab users who have access to all patients. Used to group users together so the system can assign properties to them. Primarily used to assign users to patients and only allow them to access those patients for data entry when the user does not have the seeallptordsresults permission. Used to create the unique FOID patient ID. Do not move this code from one user group to another, create a new code instead. |
InquiryGroupCode |
varchar(50) |
A code assigned by the administrator. Enter a group code. This code is the same as the entry group code except it is used for result inquiry. |
DeviceLocation |
varchar(50) |
Defines the device locations to which this user has access. Multidimensional pipe delimited value, with leading and trailing pipes. Enter valid device location code - user location code pairs. Each pair is represented by Value 1 then a dash then Value 2 where Value 1 = valid device location code Value 2 = valid user location code IE: D1-ULOC1|D2-ULOC2| The device location field is critical to associate the user with a particular label printer. The user location value is critical to associate the user to a particular physical location such as a collection facility. Both values are used to help categorize properties and are assigned to each order to allow for statistical reporting. These device locations are displayed at logon for the user to select from. If there is only one device location, the system will automatically use it. (Are just device codes, without user location, also allowed? as |dvc1|dvc2| ?) |
UserLocation |
varchar(50) |
Default user location code. Enter a valid user location code, the geographical location for the user. This code is used to group packing list contents together. |
MedicareRegion |
varchar(80) |
Default Medicare region number. Enter a valid Medicare region number. Medicare region is used as an identifying value during LMRP rules processing. Used to determine which diagnosis/CPT pair applies to a test when performing LMRP calculations. Used to match the user to the appropriate information in the FO_CPTREVIEW table. |
BillToGroup |
varchar(80) |
Populates the list of Bill To options available on the order screen Bill To field. Enter a list of concatenated single characters from the allowed values. Each character represents a Bill To option. IE: IRCWOABMSFZ See table of Bill To options below this table. |
DefaultSearchType |
varchar(50) |
Default search option in toolbar Search By drop-down list for this user. Enter AUTO or an allowed search option. Allowed options: AUTO NAME SSN PHONE DOB ACCESSION REQ.ID. Lab MR# RECENT PTS Your ID LAB ACCESSION INTEGRATED -- See Integrated Search Module for more information and instructions. (is there a default value, perhaps AUTO, if this entry is skipped?) |
CreateDate |
datetime |
Date record was created. Informational |
CreateBy |
varchar(50) |
Name of user who created the record. Informational |
EditBy |
datetime |
Name of user who last edited the record. Informational |
EditDate |
datetime |
Datetime the record was last edited. Informational (does the user enter this or the system timestamp?) |
DeactivateDate |
datetime |
Datetime the record was deactivated. Informational If this field contains a date that is before the current date, the user is deactivated and cannot login to the application. If the user is deactivated, a message will be displayed. This field is used to prevent the user from logging in to the application without removal of the user's name, without removal of the user's data record. |
MiscTestCode |
varchar(50) |
Default wild card test code. Enter a valid wild card test code. MISCREF is typically used. Used when the FreeText Code button on the order screen is clicked. |
MiscICDCode |
varchar(50) |
Default prefix for ICD codes. Enter a valid prefix. #MICD is typically used. Prefixes ICD codes so they are recognized as miscellaneous or freetext entries. |
PermGroup |
varchar(20) |
Permission group code. Required field. Enter a valid permission group code. Associates this user with a list of permissions defined in the FO_PermGroups table. |
|
varchar(50) |
Email address for user. Informational |
ICDEntryGroup |
varchar(50) |
Populates the list of Bill To options that trigger when to prompt for diagnosis codes at the time of an order. Enter a list of concatenated single characters from the allowed values. Each character represents a Bill To option. IE: IRCWOABMSFZ Allowed values: I = Insurance C = Client R = Patient/Guarantor M = Cash S = Skilled Nursing Z = Not Specified B = Insurance not skilled A = Medicare A W = Worker’s comp O = Your office (used for client users same as client) N = No charge F = Auto Accident |
PrintBarCodes |
int |
Informational, usually blank. |
Local_Install |
int |
Bit flag to indicate if FASTsystem installation is on a local user’s computer. Enter 0 Do NOT change without Rhodesapproval. 0 = remote install 1 = local install Used when the FAST system installation is on a local user’s computer instead of a terminal server and that install can potentially communicate items downstream. Local install indicates that FAST is on a local PC with a local database and is not shared with other users. |
LoginLevel |
int |
Determines if user is allowed to automatically log in. If user may log in to more than one device location, do NOT use 2. Enter an allowed value. Allowed values: 0 = prompt user for full login credentials 1 = default credentials based on OS user name but wait for the user to pick a device location before logging in 2 = auto log in user with default device/user location The system can discover the user name that has been used to log in to the Windows session. The user name is compared to the FO_Users table and if a matching entry is found, then the system will check the value of this field to see if the user should be automatically logged in. |
Def_PtLocCode |
varchar(20) |
User-level Patient Location Default. Enter a valid LIS location code defined in the FO_PTLocations table. Used as the patient location field on the order screen if no client-level maps have been defined. |
DefaultBillTo |
varchar(1) |
Default value for Bill To when a new order is created on the order screen. Enter a valid billto code, a single character. Typical value = * Enter '*' to default to I or R. Default will be I, or Insurance, if the patient has insurances defined. Default will be R, or Patient, if no insurances are defined for the patient. See the Bill To codes table below this table. |
Def_ProvCode |
varchar(50) |
Default provider/physician code used on the Report/Requisitions Options screen when the FO_Reports.PhysCodeDefault field is set to 'USER'. Enter a valid provider code. |
LISTechCode |
varchar(50) |
Default LIS tech code. Enter a valid LIS tech code. Can be sent to LIS through interfaces. |
Def_ClientCode |
varchar(50) |
Default client code used on the Report/Requisitions Options screen when the FO_Reports.PhysCodeDefault field is set to 'USER'. Enter a valid client code. |
WorkloadCodes |
varchar(80) |
Defines the list of possible workload codes for this user. Multidimensional pipe delimited value, with leading and trailing pipes. Enter valid workload codes separated by pipes. IE: |VP|VPM|VPO| |
Def_ReqName |
varchar(50) |
System report name used to print a requisition when the Req button is clicked on the order screen. Use Rhodes recommended value. Typical value: FO_ReqLabel_BC_NOLABELS |
hostOSUser |
varchar(50) |
Not Used |
hostOSpass |
varchar(50) |
Not Used |
hostIPaddress |
varchar(50) |
Not Used |
hostAppUser |
varchar(50) |
Not Used |
hostAppPass |
varchar(50) |
Not Used |
hostFunction |
varchar(50) |
Not Used |
hostPromptDelay |
int |
Not Used |
hostConnectDelay |
int |
Not Used |
hostFontName |
varchar(50) |
Not Used |
hostFontSize |
decimal(18, 2) |
Not Used |
hostCapture |
varchar(1) |
Not Used |
ProvClientSearch |
varchar(50) |
Default search type. Enter one of the allowed values: PROVIDER CLIENT LOCATION Do NOT change without Rhodes approval. |
Users_ID |
int |
ID field, a counter. Unique |
Result_Sys_User |
varchar(80) |
Default user name for a web-based result system to which the user may branch. Use Rhodes recommended value. Skip this entry to leave blank. |
Result_Sys_Password |
varchar(80) |
Default user password for a web-based result system to which the user may branch. Use Rhodes recommended value. Skip this entry to leave blank. |
FacilityIDCodes |
varchar(1000) |
Represents the facility IDs to which the system has access. Multidimensional pipe delimited value, with leading and trailing pipes. Enter a single facility ID unless the system will contain multiple versions of the patient, one for each facility ID. For multiple facilities, enter valid facility IDs separated by pipes. The system will evaluate a patient’s facility ID assignment and will not allow access to that patient if its facility ID does not match a facility ID in the list. IE: |1|2|3| |
LastPasswordDate |
datetime |
Datetime when the user is prompted and required to change their password. Timestamped with the next datetime when the user changes their password. It can be also manually entered to force a password change. |
Qualifier |
varchar(50) |
Default MPI Qualifier code. Enter a valid MPI Qualifer code. Skip this entry if user is allowed access to patients cross-referenced to multiple MPI qualifier codes. |
QualifierType |
varchar(50) |
Determines how to apply a MPI qualifier during the order process to the foreign medical record number (Client Pt ID) if the user does not provide an MPI qualifier code. Enter a valid allowed value. Typical value: CLIENTMPI Allowed values: CLIENTID = system will use the client ID in the order as an MPI qualifier code. CLIENTMPI = system will use the MPI Qualifier assigned to the client ID for the order, defined in the FO_Clients table. LOCATION = system will use the location code as an MPI qualifier. Do not use if location codes have a semicolon character. PHYSCODE = system will use the provider/physician code as an MPI Qualifier. Do not use if provider codes have a semicolon character. ENTRYGROUPCODE = system will use the user's entrygroupcode as an MPI qualifier. |
UserMessage |
varchar(350) |
Used to display a message to the user on the login screen. |
AccountLogic
update this field's Notes values per the information in the table in the Order Account Default Logic Rules information. |
varchar(50) |
Defines the rules used to assign an account number on the order screen. Enter an allowed value. Use Rhodes recommended value. UNIQUEACCT is the recommended setting if a client ID will always be used. UNIQUEACCTPROV is the recommended setting if a client ID will not always be used. Allowed values: REQID = defaults the requisition ID as the account number UNIQUEACCT = defaults a unique account number for an order based on the values of patient ID, physician, collection date, order billto and client ID UNIQUEACCTPROV = defaults a unique account number for an order based on the values of patient ID, physician, collection date and order billto MRNPHYSDATE = default the account number to be valued by the values of MRN, physician ID and collection date, ie the MRN + Ordering Phys Code + Date DATE = defaults the account number to today’s date CLIENT = if this is contained in the keyword then the system will check the FO_Clients (number) field to see if it contains an account number or the word 'ASK'. If 'ASK' is found then the system will prompt the user for an account number. CLIENTMRNPHYSDATE = same as CLIENT PROVIDER = if this is contained in the keyword then the system will check the FO_Providers (number) field to see if it contains an account number or the word 'ASK'. If 'ASK' is found then the system will prompt the user for an account number. UNIQUEACCT = system will create a unique account number for the order CVN = system will use the CV# value for the account number if it exists UNIQUEACCTPROV = system will create a unique account number for the combination of FOID, collection date and provider. UNIQUEACCTPROVBILLTO = system will create a unique account number for the combination of FOID, collection date, provider and billto UNIQUEACCTCLIENTBILLTO = system will create a unique account number for the combination of patient, client, billto and collection date UNIQUEACCTCLIENT = system will create a unique account number for the combination of patient, client and collection date UNIQUEACCTCLIENTPROVBILLTO = system will create a unique account number for the combination of patient, client, provider, billto and collection date NONE = no account number will be generated |
ScreenTimeout |
int |
Number of minutes for a screen to time out and exit. Enter an integer for the number of minutes. Recommended value: 10 |
LoginTimeout |
int |
Number of minutes for the system to time out and end the application after the last screen is timed out. Enter an integer for the number of minutes. Recommended value: 15 |
ABNcopies |
int |
Number of copies of ABN form to print. Enter an integer: 1, 2, 3, 4, or 5 Defaults to 1 |
Ins_User_Assignement |
varchar(50) |
Code that determines which insurance codes to which the user has access. Enter a valid group code. This code is linked to the value of FO_INS.INS_USER_ASSIGNEMENT and allows the user access to only the insurance codes associated with the same user group code. For example, this field may be defined as 'FRONT'. The system displays only the insurance codes that have been associated with this user group code or have a no assignment code. |
MessageGroups |
varchar(500) |
Defines a list of message groupscodes to which the user belongs and for which the user may send patient messages. Multidimensional pipe delimited value, with leading and trailing pipes. Enter valid message group codes separated by pipes. IE: |ALL|CPA|PSC1|BILL| |
DefaultTextDiagnosis |
varchar(255) |
Populates the test diagnosis drop-down on the order screen. Multidimensional pipe delimited value, with leading and trailing pipes. Enter valid test diagnoses separated by pipes. IE: |Not Given|Missing|Called Dr|Not Clear| |
DESearchDefault |
varchar(50) |
Default search by value on the Blind Duplicate Entry screen. Enter an allowed value. Skip this entry for no default. Allowed values: Lab Accession FO Accession Requisition ID Container ID |
LabelExpirationSeconds |
int |
Number of seconds system will wait for the LIS to return a lab accession value before qualifying a label to print. Enter an integer for the number of seconds. Enter 1 if FAST will be assigning the accession. |
BatchLocations |
varchar(500) |
Defines the list of batch locations to which the user has access. Multidimensional pipe delimited value, with leading and trailing pipes. Enter valid batch location codes separated by pipes. IE: |PSC1|PSC2| |
CopyOrderFields |
varchar(50) |
Turns on/off a particular field defined in the copy order logic from qualifying to be copied. Enter 1 or 0 for on or off. Use all 1 values to turn all fields on. Enter the default (requires 18 characters): '111111111111111111' See table of copy order field options below this table. |
TestPriorityForASAP |
varchar(50) |
Priority code for ASAP priority. Enter a valid priority code. IE: ASAP |
TestPriorityForStat |
varchar(50) |
Priority code for STAT priority. Enter a valid priority code. IE: STAT |
UserLocPerfLab |
varchar(500) |
Used to drive a rule that causes a test to be auto received at time of order. A multidimensional pipe delimited field, with leading and trailing pipes. Enter pairs of user location code - performing lab code values separated by pipes. This field is used to map the user's list of possible user locations to a performing lab. The rule maps each user location code to a default performing lab code. The system then compares this value to a tests performing lab during order entry. If the values match, then the system will auto-receive that order by assigning a receipt date and time. Skip this entry if automatic receipt is not required for this user. IE: |PSC1-DEFAULT|PSC2-CORELAB1|PSC3-CORELAB2| |
BillReQueueLogic |
varchar(50) |
Used in the re-queue logic for sending demographic data to the FIN system. It populates the correct trigger data, Search By field, for the re-queue interface, the BillingRequeue table. (what is the actual table name?? ) Enter an allowed value. Allowed values: LISORDX ACCESSION LABACC |
ReqHeaderMsg |
varchar(70) |
Text message to print in the requisition header. |
ReceiptFooterMsg |
varchar(100) |
Text message to print in the requisition footer. |
Manager |
varchar(50) |
Manager assigned to this user. Enter a valid code for the manager. Written to each order the user creates to use in statistical queries. |
CollectionLocations |
varchar(255) |
Used to validate the collection location code entered on the order screen by this user. Multidimensional pipe delimited value, with leading and trailing pipes. Enter valid collection location codes separated by pipes. IE: |LOC1|LOC2|LOC3| |
AssignedToClientCodes |
varchar(255) |
Defines the list of client IDs the user may use during order entry. Multidimensional pipe delimited value, with leading and trailing pipes. Enter valid client IDs separated by pipes. It causes the system to bypass provider to client mapping and only display the client IDs in this list. IE: CLIENT1|CLIENT2|CLIENT3 |
ArchiveRackIDs |
varchar(255) |
Populates the drop-down list of rack IDs the user may use during order entry. Multidimensional pipe delimited value, with leading and trailing pipes. Enter valid rack IDs separated by pipes. |
SO_Default_Days |
int (4) |
Number of days to show a standing order on the Requisition History screen. Enter an integer for the number of days. |
DevLocScanFilePaths |
varchar(500) |
Future Use |
ImageCategories |
varchar(500) |
Defines category and location of scanned data storage. A multidimensional pipe delimited field, with leading and trailing pipes. Enter pairs of valid category code = file path values separated by pipes. Format as: |categoryCode = FilePath| categoryCode = FilePath| IE: |REQ=C:\|INS_Card=C:\|ABN=C:\| |
ImagingSystemURL |
varchar(80) |
URL for imaging system. Enter valid URL. If present, FAST will turn on button within application to provide easy navigation for scanning. (is this the default path for where images will be stored when scanned, what button is turned on?) |
Main_Pt_Srch_List |
varchar(255) |
Populates the drop-down list of search options for this user when performing search in FAST. Multidimensional pipe delimited value, with leading and trailing pipes. Enter allowed values separated by pipes. Allowed values: AUTO NAME SSN PHONE DOB ACCESSION REQ.ID. Lab MR# RECENT PTS Your ID LAB ACCESSION INTEGRATED |
AdvancedSearchDefaultChecks |
varchar(500) |
Defines fields that default to checked on the advanced search screen. Allowed values include: (where C=client identifier and L=Lab identifier) C_MRN C_ACC CACCT (is this correct with no underscore?) C_ORD C_REQID L_ACC L_MRN L_REQID L_NAME L_PTLOC L_CLIENT L_DOB L_LABACC L_PROV L_SSN L_TEL L_USERLOC |
CollectionHUBCodes |
varchar(max) |
Defines HUBs to which this user has access. User will only have access to HUBs defined here. Multidimensional pipe delimited value, with leading and trailing pipes. Enter valid collection HUB codes separated by pipes. Valid collection HUB codes are defined in the FO_Hub_Definitions table. |
ClientPtAccessGroupCodes |
varchar(MAX) |
Defines client patient access group codes to which this user has access. This limits the list of patients presented to this user when searching by RECENT PTS option. Multidimensional pipe delimited value, with leading and trailing pipes. Enter valid client patient access group codes separated by pipes. The user can only access patients with a matching ClientPTAccessGroupCode values. RecentPatientSearchType must be set to PTACCESSGROUP for this field to be referenced. |
RecentPatientSearchType |
varchar(50) |
Search type used when using recent patients search option. Enter an allowed value. Allowed values: USERLOCATION ENTRYGROUPCODE PTACCESSGROUP MPI See Recent Patients Search Configuration Rule for more information. |
RecentPatientSearchDays |
varchar(50) |
Used with recent patients search option to define what is recent activity. Enter an integer for the number of days from the patient's edit date. |
CommonTestListCode |
varchar(50) |
Default common test list for this user to view. Enter a code for the common test list. Based on permission, user can add and delete from test list. (where is the common test list code, are there allowed values?) |
WorkFlowMethods |
varchar(255) |
Populates the drop-down list of workflow methods available to this user on the Integrated Search Screen. Multidimensional pipe delimited value, with leading and trailing pipes. Enter allowed values separated by pipes. Allowed values: PATIENT PRESENTS SPECIMEN PRESENTS INDUSTRIAL TOX This takes priority over the system-level value in FO_LabInfo. |
DefaultWorkFlowMethod |
varchar(50)s |
Default workflow method for this user. Enter a valid workflow method. This takes priority over the system-level default value and the UserLocation DefaultWorkflow value. (and where is the UserLocation DefaultWorkflow defined?) |
Bill To Options
The following table lists the Bill To options available. Use one or more of the letter codes in the FO_Users.BillToGroup field.
Letter Code |
Long Code Appearing In Drop Down |
Billing System Charge To |
I |
Insurance |
According to rules |
R |
Patient/Guarantor |
P |
C |
Client |
C |
W |
Worker’s Comp |
Customized |
O |
Your Office (same as client) |
C |
M |
Cash Payment |
CASH |
N |
No Charge |
NS |
B |
Insurance Not Skilled |
According to rules |
A |
Medicare A Skilled |
According to rules |
S |
Skilled Nursing (Nursing Home) |
According to rules |
F |
Auto Accident |
Customized |
Z |
Not Specified |
NS |
* |
Patient or Insurance |
Looks at demographics to decide. |
Not in the FO_Users.BillToGroup field definition, need to add it.
Copy Order Fields
The copy order field options below, set in the FO_Users.CopyOrderFields field, are used for the Copy Order Rule.
An acceptable value for the FO_Users.CopyOrderFields field is created by a string of 1s and 0s, each 1 or 0 turning on or off an option listed below. The string should contain a number for each option below, a string of 18 characters.
Copy Order Field -- Allowed Values | |
---|---|
Position |
Description |
1 |
BILL TO field |
2 |
Account Number |
3 |
Client Visit Number |
4 |
Ordering Physician Code and Name |
5 |
Client Code and Name |
6 |
Copy To 1-4 Code and Name |
7 |
Copy To Client |
8 |
Location Code and Name |
9 |
Order Test Codes |
10 |
Diagnosis Codes By Test |
11 |
Test Collection Date and Time |
12 |
Order Level Collection Date and Time |
13 |
Order Episode ID |
14 |
Order Referral Information |
15 |
Order Injury Related Data |
16 |
Order LMP related Data |
17 |
Test Level Questions and Answers |
18 |
Requisition ID at Order level |
For example, to turn on options 1, 2, 3, 6, 10, 11, 12, 13, 17 and 18, enter the FO_Users.CopyOrderFields value as 111001000111100011.